package com.xframe.domain.e3sp.basedata;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.xframe.domain.BaseModel;
import com.xframe.xdal.core.annotation.*;
import com.xframe.xdal.core.constant.AutoFillType;
import lombok.Data;
import lombok.experimental.Accessors;

import java.util.Date;


/**
 * @Description: 目录清单
 * @ClassName: com.xframe.domain.e3sp.basedata.CatalogBaseView
 * @Author: xufeng
 * @CreateTime: 2024/01/02
 **/
@Data
@Accessors(chain=true)
@XTable(value = "v_t02_catalog", label = "目录清单")
@XSelectItem(keyName = "catalogId",codeName = "sparePartNo",textName = "sparePartNo")
public class CatalogBaseView  extends BaseModel {

    /**
     * 目录清单ID
     */
    @AutoFill(AutoFillType.Snowflake)
    @XColumn(primaryKeyFlag = true,uniqueFlag = true,desc = "目录清单ID")
    private Long catalogId;

    /**
     * 备件ID
     */
    @XQueryCondition
    @XColumn(desc = "备件ID")
    private Long sparePartId;
    /**
     * PCID
     */
    @XQueryCondition
    @XColumn(desc = "PCID")
    private Long pcId;

    /**
     * 节号ID
     */
    @XQueryCondition
    @XColumn(desc = "节号ID")
    private Long sectionId;



    /**
     * 品种ID
     */
    @XQueryCondition
    @XColumn(desc = "品种ID")
    private Long varietyId;


    /**
     * 索引号
     */
    @XQueryCondition
    @XColumn(desc = "索引号",length = 50,nullFlag = true)
    @XGridTableRef
    private String indexNo;

    /**
     * SPECODE
     */
    @XQueryCondition
    @XColumn(desc = "SPECODE",length = 50,nullFlag = true)
    @XGridTableRef
    private String speCode;

    /**
     * 排序码
     */
    @XColumn(desc = "排序码",length = 50,nullFlag = true)
    private String orderNo;

    /**
     * 启用年月
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @XColumn(desc = "启用年月",nullFlag = true)
    private Date actTime;

    /**
     * 停用年月
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @XColumn(desc = "停用年月",nullFlag = true)
    private Date stopTime;

    /**
     * 数量
     */
    @XQueryCondition
    @XColumn(desc = "数量",nullFlag = true)
    private Integer qty;

    /**
     * 说明
     */
    @XQueryCondition
    @XColumn(desc = "说明",length = 500,nullFlag = true)
    @XGridTableRef
    private String illustrate;

    /**
     * 依据
     */
    @XQueryCondition
    @XColumn(desc = "依据",length = 200,nullFlag = true)
    @XGridTableRef
    private String according;

    /**
     * 技术摘要
     */
    @XQueryCondition
    @XColumn(desc = "技术摘要",length = 200,nullFlag = true)
    @XGridTableRef
    private String summary;

    /**
     * 发文号
     */
    @XQueryCondition
    @XColumn(desc = "发文号",length = 50,nullFlag = true)
    @XGridTableRef
    private String docNumber;


    /**
     * 备注
     */
    @XColumn(name = "remark",desc = "备注",length = 500,nullFlag = true)
    private String remark;
    /**
     * 品种编码
     */
    @XColumn(name = "variety_code",desc = "品种编码",length = 200)
    private String varietyCode;

    /**
     * 中文名称
     */
    @XGridTableRef
    @XColumn(name = "vr_name_cn",desc = "品种名称",length = 200)
    private String vrNameCn;

    /**
     * 品种英文名称
     */
    @XColumn(name = "vr_name_en",desc = "品种英文名称",nullFlag = true,length = 200)
    private String vrNameEn;



    /**
     * PC
     */
    @XQueryCondition
    @XColumn(name = "pc", uniqueFlag = true,desc = "PC",length = 200)
    private String pc;


    /**
     * PC名称
     */
    @XQueryCondition
    @XColumn(name = "pc_name_cn",desc = "PC名称",length = 200)
    private String pcNameCn;

    /**
     * PC英文名称
     */
    @XQueryCondition
    @XColumn(name = "pc_name_en",desc = "PC英文名称",length = 200,nullFlag = true)
    private String pcNameEn;

    /**
     * DC_ID
     */
    @XColumn(name = "dc_id",desc = "DCID")
    private Long dcId;

    /**
     * SCID
     */
    @XColumn(name = "sc_id",desc = "SCID")
    private Long scId;

    /**
     * DC
     */
    @XColumn(name = "dc",desc = "DC",length = 200)
    private String dc;


    /**
     * DC名称
     */
    @XColumn(name = "dc_name_cn",desc = "DC名称",length = 200)
    private String dcNameCn;

    /**
     * DC英文名称
     */
    @XColumn(name = "dc_name_en",desc = "DC英文名称",length = 200,nullFlag = true)
    private String dcNameEn;

    /**
     * SC
     */
    @XColumn(name = "sc",desc = "SC",length = 200)
    private String sc;

    /**
     * SC名称
     */
    @XColumn(name = "sc_name_cn",desc = "SC名称",length = 200)
    private String scNameCn;

    /**
     * SC英文名称
     */
    @XColumn(name = "sc_name_en",desc = "SC英文名称",length = 200,nullFlag = true)
    private String scNameEn;


    /**
     * 节号
     */
    @XColumn(name = "section_no",desc = "节号",length = 200)
    private String sectionNo;

    /**
     * 节名称
     */
    @XColumn(name = "sec_name_cn",desc = "节名称",length = 200)
    private String secNameCn;

    /**
     * 节英文名称
     */
    @XGridTableRef
    @XColumn(name = "sec_name_en",desc = "节英文名称",length = 200,nullFlag = true)
    private String secNameEn;

    /**
     * 章号
     */
    @XColumn(name = "chapter_no",desc = "章号",length = 200)
    private String chapterNo;


    /**
     * 章名称
     */
    @XColumn(name = "p_name_cn",desc = "章名称",length = 200)
    private String chapterNameCn;

    /**
     * 章英文名称
     */
    @XColumn(name = "p_name_en",desc = "章英文名称",length = 200,nullFlag = true)
    private String chapterNameEn;

    /**
     * 备件编码
     */
    @XQueryCondition
    @XGridTableRef
    @XColumn(name = "spare_part_no",desc = "备件编码",length = 100)
    private String sparePartNo;

    /**
     * 备件名称
     */
    @XQueryCondition
    @XGridTableRef
    @XColumn(name = "spare_part_name_cn",desc = "备件名称",length = 200,nullFlag = true)
    private String sparePartNameCn;

    /**
     * 备件英文名称
     */
    @XGridTableRef
    @XColumn(name = "spare_part_name_en",desc = "备件英文名称",length = 200,nullFlag = true)
    private String sparePartNameEn;
}
